INSERT INTO sys_menu( pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date)
VALUES (0, '${moduleName}/${classname}', '${moduleName}:${classname}:page', 0, 0, '', '0', 1067246875800000001, now(), 1067246875800000001, now());
-- 功能菜单
SELECT @menuId := LAST_INSERT_ID();
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language)
VALUES ('sys_menu',@menuId, 'name', '${tableComment}', 'zh-CN');

-- 新增菜单
INSERT INTO sys_menu(pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date)
VALUES (@menuId, null, '${moduleName}:${classname}:save', '1', 0,null, 0, 1067246875800000001, now(), 1067246875800000001, now());
SELECT @saveMenuId := LAST_INSERT_ID();
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language)
VALUES ('sys_menu',@saveMenuId, 'name', '${tableComment}-新增', 'zh-CN');

-- 修改菜单
INSERT INTO sys_menu(pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date)
VALUES (@menuId, null, '${moduleName}:${classname}:update', '1', 0,null, 0, 1067246875800000001, now(), 1067246875800000001, now());
SELECT @updateMenuId := LAST_INSERT_ID();
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language)
VALUES ('sys_menu',@updateMenuId, 'name', '${tableComment}-修改', 'zh-CN');

-- 删除菜单
INSERT INTO sys_menu(pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date)
VALUES (@menuId, null, '${moduleName}:${classname}:delete', '1', 0,null, 0, 1067246875800000001, now(), 1067246875800000001, now());
SELECT @deleteMenuId := LAST_INSERT_ID();
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language)
VALUES ('sys_menu',@deleteMenuId, 'name', '${tableComment}-删除', 'zh-CN');

-- 导出菜单
INSERT INTO sys_menu(pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date)
VALUES (@menuId, null, '${moduleName}:${classname}:export', '1', 0,null, 0, 1067246875800000001, now(), 1067246875800000001, now());
SELECT @exportMenuId := LAST_INSERT_ID();
INSERT INTO sys_language(table_name, table_id, field_name, field_value, language)
VALUES ('sys_menu',@exportMenuId, 'name', '${tableComment}-导出', 'zh-CN');
